Release 10.1A: OpenEdge Reporting:
Query/Results for Windows

Query creation overview

The primary tasks involved in creating a query are:

Select the database tables to be included in the query. When you create a query, you select the tables that contain the information you want Results to retrieve.
Select the view you want to use to process the information retrieved by the query. A view is an on-screen display of only part of the information in a database, as specified in a query. A view can display data from one or more tables or from other views.

Table 3–1 lists these views.

Table 3–1: Query views 

View	Purpose
Browse	Lists the tables in all connected databases from which you can add or remove to build a query. This view is the initial, basic view for all other views described in this table derive data.
Report	Creates multi-line and master-detail reports for printing. Provides calculated values and totals. You can format the headers, footers, and page breaks.
Form	Allows you to view, update, add, and delete individual records in the database.
Label	Formats and prints records in a variety of label formats, including mailing and inventory labels.
Export	Formats records to export to other applications.

Select the fields you want to display.

When you create a query, Results retrieves all the fields in each table you include in the query. However, you might want to limit the number of display fields, which are the fields that you select to appear in the view, whether on-screen or printed. For example, if you create a query that accesses the Customer table, you might want to view only those fields that contain address information. Limiting the display fields does not alter the contents of the query; it simply limits the number of fields you view.

Once you create the initial query, you can modify its contents, select a new query view, or select different display fields.